﻿CREATE PROCEDURE [dbo].[proc_Finance_Outlay_GetItem]
	(
		
		@Id int
	)
AS
begin
	SELECT *,(SELECT c.CompanyName
	            FROM Company c WHERE c.Id=[CompanyIdCur]) AS CompanyCurName,
	            (SELECT d.DName
	            FROM Department d WHERE d.id=DepartmentIdCur) AS DepCurName FROM Finance_Outlay WHERE id=@Id

end
	RETURN